{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["StartHere","5.ID","Financial information ","SI and regression Pt 1","Current operations Pt2 & Pt3 ","Franchise operations Pt2 & Pt3","Expected Values Pt3","Sheet9"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"StartHere","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,2,10,2],[11,2,12,2]]}
[]
[null,"Student Identification Sheet (version5.2)"]
[]
[null,"Name","Dallan Delgado"," <<- enter your name here",null,null,"(1)","Add your name to Cell C4 and your Student ID to cell C6. Then  Click [Start Here] to finish loading data."]
[null,null,null,null,null,null,"(2)","Change the file name to include your name. "]
[null,"Student ID","002-46-2565"," <<- enter your Student ID here",null,null,"(3)","When done with your work, Click [I'm Done]"]
[null,null,null,null,null,null,"(3)","Upload the file to the applicable iCollege"]
[null,"Date/time",{"$f":"NOW()","v":"2021-04-24T01:48:08.510"},null,null,null,null," assignment folder to receive credit for this workshop/tutorial"]
[null,null,"Spring 2021",null,null,null,"(4)","Never use a file created or started by another student (that is academic dishonesty).\nAll text, codes, writing, data entry, formulas, configuration and instructions must be performed by the individual submitting the work."]
[null,null,"You must use Excel Desktop. Cloud Excel 365 will not work for this class.",null,"2021-04-21T23:08:53.180","Dallan Delgado started S01"]
[]
[null,null,"Collaboration Started"]
[]
[null,null,"Individual Challenge started"]
[null,null,"Kurt Schmitz © 2020 Do not post or reproduce."]
[]
[null,"Excel release",{"$f":"INFO(\"release\")","v":"16.0"},"<< Mac Users below 16.24, please update!"]
[null,"OS",{"$f":"INFO(\"OSVERSION\")","v":"Windows (32-bit) NT :.00"},"<< Windows users with version 16.0 are good to go."]

{"sheet":"5.ID","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Do Not Alter or Delete this Worksheet or you submission cannot be graded!",null,null,null,"DirVer"]
["Action","Name","Panther ID","Date/Time","S01"]
["Start S01","Dallan Delgado","002-46-2565","2021-04-23T12:27:43.190","User"]
["Start S01","Dallan Delgado","002-46-2565","2021-04-23T12:27:18.760","C:\\Users\\owna\\AppData\\Local\\Temp"]
["Start S01","Dallan Delgado","002-46-2565","2021-04-21T23:08:52.900","Welcome to Microsoft Excel version 16.0 build 13901 running on Windows (32-bit) NT 10.00!"]
["Starter Sheet","None",0,"2020-01-01","S01"]
[null,null,null,null,"User"]
[null,null,null,null,"C:\\Users\\owna\\AppData\\Local\\Temp"]
[null,null,null,null,"Welcome to Microsoft Excel version 16.0 build 13901 running on Windows (32-bit) NT 10.00!"]
[null,null,null,null,"S01"]
[null,null,null,null,"Dallan Delgado"]
[]
[null,null,null,null,"Welcome to Microsoft Excel version 16.48 build 411 running on Macintosh (Intel) Version 11.0.1 (Build 20B29)!"]

{"sheet":"Financial information ","index":2,"n_rows":64,"n_cols":26,"rows_kept":64,"cut":false,"hidden":false,"merged":[[36,1,36,2]]}
["Donut Information ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]
["Based on the below data, create the profit model for Donuts to Go.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado"]
["Assume that each customer will buy one donut and one cup of coffee"]
[" "]
[null,null,null,null,null,"Enter totals ",null,null,null,"income ","expenses","profit","percentage"]
[null,"Time period",null,null,"Fixed Costs",7050,null,null,"Donut",3.5,0.5,{"$f":"J6-K6","v":3},{"$f":"L6/J6","v":0.8571428571428571}]
["Revenue: Cup of Coffee",null,4,null,"Varible Costs",0.85]
["Revenue: Donut"," ",3.5,null,"Coffee",2000]
["Donut ingredients per donunt)","per donut",0.5,null,"Donut",2000]
["paper products: napkins, plates etc"]
["Insurance","month",200]
[" "]
["Maintenance & Repairs to equipment","month",0,null,null,{"$f":"C11+C14+C17+C18+C20+C21+C23+C24+C25+C26+C19","v":7050}]
["Marketing & Promotion: Advertising","month",50]
["Coffee ","per cup",0.25]
["Coffee cups ","per cup",0.1]
["Payroll:  Wages (Owner/ Manager)","month",2500]
["Payroll:  Wages (per Employees)","month",1000,null,null,null,null,null," "]
["Donut and Coffee equipment rent ","month",500]
["Professional Fees: Accounting","month",50]
["Professional Fees: Legal","month",25]
["Powdered and Liquid Beverages",null,0]
["Rent","month",1000]
["Previous research expense for Donuts advancements",null,1500]
["Supplies: Office","month",25]
["Utilities","month",200," "]
[" ",null," "]
[]
[]
["Additional Data"]
["Monthly Production","Lost Sales","Day old revenue","High demand, % above Average","Low Demand, % below average"]
[4000,3,1.25,0.22,0.26]
["Franchise "]
["Monthly Fixed Expense increase",7000]
["Monthly Production Increase",0.32]
["Monthly demand increase",0.24]
["States of Natures ","probabilities "]
["High demand",0.2]
["Average demand",0.55000000000000004]
["Low demand",0.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total "]

{"sheet":"SI and regression Pt 1","index":3,"n_rows":102,"n_cols":27,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["Month","Demand","Yearly average","centered moving average","Seasonal Index","Average SI","Deseasonalized","Time period",null,null,"Regression Output"]
["2018-01-01",2475,null,null,null,null,null,1,null,"SUMMARY OUTPUT"]
["2018-02-01",2665.5,null,null,null,null,null,2]
["2018-03-01",3597.5,null,null,null,null,null,3,null,"Regression Statistics"]
["2018-04-01",3104,null,null,null,null,null,4,null,"Multiple R",0.9999977883667549]
["2018-05-01",2410,null,null,null,null,null,5,null,"R Square",0.99999557673840112]
["2018-06-01",3592,null,null,null,null,null,6,null,"Adjusted R Square",0.99999544664247164]
["2018-07-01",2740,null,{"$f":"AVERAGE(AVERAGE(B2:B13),AVERAGE(B3:B14))","v":3044.333333333333},{"$f":"B8/D8","v":0.9000328479141575},{"$f":"AVERAGEIF(A$8:A$31,A8,E$8:E$31)","v":0.9000328479141575},{"$f":"B8/F8","v":3044.333333333333},7,null,"Standard Error",0.68457659593646991]
["2018-08-01",2683.5,null,{"$f":"AVERAGE(AVERAGE(B3:B14),AVERAGE(B4:B15))","v":3042.895833333333},{"$f":"B9/D9","v":0.88189019505816146},{"$f":"AVERAGEIF(A$8:A$31,A9,E$8:E$31)","v":0.88189019505816146},{"$f":"B9/F9","v":3042.895833333333},8,null,"Observations",36]
["2018-09-01",2697.5,null,3022.854166666667,0.8923685534504503,0.8923685534504503,3022.854166666667,9]
["2018-10-01",3090,null,2991.75,1.0328403108548507,1.0328403108548507,2991.7500000000005,10,null,"ANOVA"]
["2018-11-01",3342.5,"Put yearly average in below cell ",3037.3541666666665,1.1004643569993073,1.1004643569993073,3037.3541666666665,11,null,null,"df","SS","MS","F","Significance F"]
["2018-12-01",4304.5,{"$f":"AVERAGE(B2:B13)","v":3058.5},3082.020833333333,1.3966485733792089,1.3966485733792089,3082.020833333333,12,null,"Regression",1,3602288.2882882878,3602288.2882882878,7686601.5831130361,1.2901293445688044E-92]
["2019-01-01",2135,null,3084,0.69228274967574577,0.69228274967574577,3084,13,null,"Residual",34,15.933933933934803,0.46864511570396478]
["2019-02-01",2971,null,3101.645833333333,0.95787854566460018,0.95787854566460018,3101.645833333333,14,null,"Total",35,3602304.2222222215]
["2019-03-01",2811,null,3133.3125,0.89713362455867396,0.89713362455867396,3133.3125,15]
["2019-04-01",3144,null,3175.8333333333335,0.98997638415114142,0.98997638415114142,3175.8333333333335,16,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
["2019-05-01",3464.5,null,3241.041666666667,1.0689464549720382,1.0689464549720382,3241.041666666667,17,null,"Intercept",43069.444444444445,0.23303073387597797,184823.02195969812,1.2544201694138548E-154,43068.970869015022,43069.918019873869,43068.970869015022,43069.918019873869]
["2019-06-01",3609.5,null,3307.375,1.0913488793983144,1.0913488793983144,3307.375,18,null,"X Variable 1",30.45045045045044,1.0983140416637401E-2,2772.4721068232643,1.2901293445688044E-92,30.428130023643664,30.472770877257215,30.428130023643664,30.472770877257215]
["2019-07-01",2770,null,3354.458333333333,0.82576670351646453,0.82576670351646453,3354.458333333333,19]
["2019-08-01",3077,null,3375.75,0.9115011478930608,0.9115011478930608,3375.75,20]
["2019-09-01",3064,null,3383.375,0.90560461078065546,0.90560461078065546,3383.375,21]
["2019-10-01",3744,null,3405.375,1.0994383878427485,1.0994383878427485,3405.3750000000005,22]
["2019-11-01",4253.5,"Put yearly average in below cell ",3443.416666666667,1.2352556811306599,1.2352556811306599,3443.416666666667,23]
["2019-12-01",4985.5,{"$f":"AVERAGE(B14:B25)","v":3335.75},3476.125,1.4342119457729512,1.4342119457729512,3476.125,24]
["2020-01-01",2584,null,3498.375,0.73862864901561442,0.73862864901561442,3498.375,25]
["2020-02-01",3033,null,3523.729166666667,0.86073584448293994,0.86073584448293994,3523.729166666667,26]
["2020-03-01",2932,null,3536.1458333333335,0.82915132412289738,0.82915132412289738,3536.1458333333335,27]
["2020-04-01",3551,null,3549.625,1.0003873648624855,1.0003873648624855,3549.625,28]
["2020-05-01",3970.5,null,3585.8125,1.1072804280759243,1.1072804280759243,3585.8124999999995,29]
["2020-06-01",3888.5,null,3596.5625,1.0811712572769137,1.0811712572769137,3596.5625,30]
["2020-07-01",3025,null,null,null,null,null,31]
["2020-08-01",3430.5,null,null,null,null,null,32]
["2020-09-01",3008.5,null,null,null,null,null,33]
["2020-10-01",4123,null,null,null,null,null,34]
["2020-11-01",4743,"Put yearly average in below cell ",null,null,null,null,35,"Use the average seasonal Index  in the column for year 2018"]
["2020-12-01",4754,{"$f":"AVERAGE(B26:B37)","v":3586.9166666666665},null,null,null,null,36,"Seasonalized forecast"]
[null,null,null,null,null,null,null,null,null,null,"When you move your forecast to the profit models, you must use an equation, not just copy the values"]
[]
[null,"Intercept"]
[null,"slope",{"$f":"SLOPE(demand,periods)","v":33.74684684684685}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado","Dallan Delgado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021","Spring 2021"]

{"sheet":"Current operations Pt2 & Pt3 ","index":4,"n_rows":201,"n_cols":26,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["CURRENT OPERATIONS",null,null,null,"Monthly Production","Lost Sales","Day old revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test"]
["Part 2",null,null,null,4000,3,1.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer 2020 "]
["AVERAGE DEMAND"]
["Month ","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Demand",4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000]
["satisfied demand",{"$f":"B5-3","v":3997},{"$f":"C5-3","v":3997},3997,3997,3997,3997,3997,3997,3997,3997,3997,3997]
["Extra donuts(over) ",{"$f":"'Financial information '!$D$32*B5","v":880},{"$f":"'Financial information '!$D$32*C5","v":880},{"$f":"'Financial information '!$D$32*D5","v":880},{"$f":"'Financial information '!$D$32*E5","v":880},{"$f":"'Financial information '!$D$32*F5","v":880},{"$f":"'Financial information '!$D$32*G5","v":880},{"$f":"'Financial information '!$D$32*H5","v":880},{"$f":"'Financial information '!$D$32*I5","v":880},{"$f":"'Financial information '!$D$32*J5","v":880},{"$f":"'Financial information '!$D$32*K5","v":880},{"$f":"'Financial information '!$D$32*L5","v":880},{"$f":"'Financial information '!$D$32*M5","v":880}]
["Unsatisfied customers (short)",{"$f":"'Financial information '!$E$32*B5","v":1040},{"$f":"'Financial information '!$E$32*C5","v":1040},{"$f":"'Financial information '!$E$32*D5","v":1040},{"$f":"'Financial information '!$E$32*E5","v":1040},{"$f":"'Financial information '!$E$32*F5","v":1040},{"$f":"'Financial information '!$E$32*G5","v":1040},{"$f":"'Financial information '!$E$32*H5","v":1040},{"$f":"'Financial information '!$E$32*I5","v":1040},{"$f":"'Financial information '!$E$32*J5","v":1040},{"$f":"'Financial information '!$E$32*K5","v":1040},{"$f":"'Financial information '!$E$32*L5","v":1040},{"$f":"'Financial information '!$E$32*M5","v":1040}]
["Revenue"]
["coffee ",{"$f":"'Financial information '!$C$7*2000","v":8000},{"$f":"'Financial information '!$C$7*2000","v":8000},{"$f":"'Financial information '!$C$7*2000","v":8000},{"$f":"'Financial information '!$C$7*2000","v":8000},{"$f":"'Financial information '!$C$7*2000","v":8000},{"$f":"'Financial information '!$C$7*2000","v":8000},{"$f":"'Financial information '!$C$7*2000","v":8000},{"$f":"'Financial information '!$C$7*2000","v":8000},{"$f":"'Financial information '!$C$7*2000","v":8000},{"$f":"'Financial information '!$C$7*2000","v":8000},{"$f":"'Financial information '!$C$7*2000","v":8000},{"$f":"'Financial information '!$C$7*2000","v":8000}]
["donut",{"$f":"'Financial information '!$C$8*2000","v":7000},{"$f":"'Financial information '!$C$8*2000","v":7000},{"$f":"'Financial information '!$C$8*2000","v":7000},{"$f":"'Financial information '!$C$8*2000","v":7000},{"$f":"'Financial information '!$C$8*2000","v":7000},{"$f":"'Financial information '!$C$8*2000","v":7000},{"$f":"'Financial information '!$C$8*2000","v":7000},{"$f":"'Financial information '!$C$8*2000","v":7000},{"$f":"'Financial information '!$C$8*2000","v":7000},{"$f":"'Financial information '!$C$8*2000","v":7000},{"$f":"'Financial information '!$C$8*2000","v":7000},{"$f":"'Financial information '!$C$8*2000","v":7000}]
["Revenue from day old sales ",{"$f":"1.25*4000","v":5000},{"$f":"1.25*4000","v":5000},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000]
["Total Revenue",{"$f":"SUM(B10:B12)","v":20000},{"$f":"SUM(C10:C12)","v":20000},20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]
["Expenses"]
["Fixed Expenses",7050,7050,7050,7050,7050,7050,7050,7050,7050,7050,7050,7050]
["Total Fixed Expense",7050,7050,7050,7050,7050,7050,7050,7050,7050,7050,7050,7050]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"0.35*2000","v":700},{"$f":"0.35*2000","v":700},700,700,700,700,700,700,700,700,700,700]
["Donut Variable expense",{"$f":"0.5*2000","v":1000},{"$f":"0.5*2000","v":1000},1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
["Total Variable Expenses",{"$f":"B19+B20","v":1700},{"$f":"C19+C20","v":1700},1700,1700,1700,1700,1700,1700,1700,1700,1700,1700]
["Expenses: due to lost sales",{"$f":"0.85*3","v":2.5499999999999998},{"$f":"0.85*3","v":2.5499999999999998},2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998]
["Total  Expenses",{"$f":"B21+B22+B16","v":8752.5499999999993},{"$f":"C21+C22+C16","v":8752.5499999999993},8752.5499999999993,8752.5499999999993,8752.5499999999993,8752.5499999999993,8752.5499999999993,8752.5499999999993,8752.5499999999993,8752.5499999999993,8752.5499999999993,8752.5499999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B13-B23","v":11247.45},{"$f":"C13-C23","v":11247.45},11247.45,11247.45,11247.45,11247.45,11247.45,11247.45,11247.45,11247.45,11247.45,11247.45]
[]
["Part 3","You should be able to copy from average to high and low and then just make some modifications"]
["HIGH DEMAND"]
["Month "]
["Demand",{"$f":"(4000*20%)+4000","v":4800}]
["satisfied demand",{"$f":"B30-3","v":4797}]
["Extra donuts(over) ",{"$f":"B30*'Financial information '!D32","v":1056}]
["Unsatisfied customers (short)",{"$f":"26%*B30","v":1248}]
["Revenue"]
["coffee ",{"$f":"'Financial information '!C7*2400","v":9600}]
["donut",{"$f":"'Financial information '!C8*2400","v":8400}]
["Revenue from day old sales ",{"$f":"1.25*B30","v":6000}]
["Total Revenue",{"$f":"SUM(B35:B37)","v":24000}]
["Expenses"]
["Fixed Expenses",{"$f":"+B15","v":7050}]
["Total Fixed Expense",{"$f":"+B16","v":7050}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"0.35*2400","v":840}]
["Donut Variable expense",{"$f":"0.5*2400","v":1200}]
["Total Variable Expenses",{"$f":"B44+B45","v":2040}]
["Expenses: due to lost sales",{"$f":"0.85*3","v":2.5499999999999998}]
["Total  Expenses",{"$f":"B46+B47","v":2042.55}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B38-B41-B48","v":14907.45}]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand",{"$f":" 4000-(4000*'Financial information '!B40)","v":3000}]
["satisfied demand",{"$f":"B55-3","v":2997}]
["Extra donuts(over) ",{"$f":"22%*B55","v":660}]
["Unsatisfied customers (short)",{"$f":"B55-B56","v":3}]
["Revenue"]
["coffee ",{"$f":"'Financial information '!C7*1500","v":6000}]
["donut",{"$f":"'Financial information '!C8*1500","v":5250}]
["Revenue from day old sales ",{"$f":"B55*1.25","v":3750}]
["Total Revenue",{"$f":"SUM(B60:B62)","v":15000}]
["Expenses"]
["Fixed Expenses",{"$f":"B40","v":7050}]
["Total Fixed Expense",{"$f":"B41","v":7050}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"0.35*1500","v":525}]
["Donut Variable expense",{"$f":"0.5*1500","v":750}]
["Total Variable Expenses",{"$f":"B69+B70","v":1275}]
["Expenses: due to lost sales",{"$f":"0.85*3","v":2.5499999999999998}]
["Total  Expenses",{"$f":"B71+B72+B66","v":8327.5499999999993}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B63-B73","v":6672.4500000000007}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallan Delgado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2021"]

{"sheet":"Franchise operations Pt2 & Pt3","index":5,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["FRANCHISE",null,null,null,"Monthly Production","Lost Sales","Day old revenue"]
["Part 2",null,null,null,4000,3,1.25]
["AVERAGE DEMAND"]
["Month ","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Demand",4000,{"$f":"'Franchise operations Pt2 & Pt3'!B5*124%","v":4960},{"$f":"'Franchise operations Pt2 & Pt3'!C5*124%","v":6150.4},{"$f":"'Franchise operations Pt2 & Pt3'!D5*124%","v":7626.4959999999992},{"$f":"'Franchise operations Pt2 & Pt3'!E5*124%","v":9456.8550399999986},{"$f":"'Franchise operations Pt2 & Pt3'!F5*124%","v":11726.500249599998},{"$f":"'Franchise operations Pt2 & Pt3'!G5*124%","v":14540.860309503998},{"$f":"'Franchise operations Pt2 & Pt3'!H5*124%","v":18030.666783784956},{"$f":"'Franchise operations Pt2 & Pt3'!I5*124%","v":22358.026811893345},{"$f":"'Franchise operations Pt2 & Pt3'!J5*124%","v":27723.953246747747},{"$f":"'Franchise operations Pt2 & Pt3'!K5*124%","v":34377.702025967206},{"$f":"'Franchise operations Pt2 & Pt3'!L5*124%","v":42628.350512199337}]
["satisfied demand",{"$f":"B5-3","v":3997},{"$f":"'Franchise operations Pt2 & Pt3'!B6*124%","v":4956.28},{"$f":"'Franchise operations Pt2 & Pt3'!C6*124%","v":6145.7871999999998},{"$f":"'Franchise operations Pt2 & Pt3'!D6*124%","v":7620.7761279999995},{"$f":"'Franchise operations Pt2 & Pt3'!E6*124%","v":9449.7623987199986},{"$f":"'Franchise operations Pt2 & Pt3'!F6*124%","v":11717.705374412799},{"$f":"'Franchise operations Pt2 & Pt3'!G6*124%","v":14529.954664271871},{"$f":"'Franchise operations Pt2 & Pt3'!H6*124%","v":18017.14378369712},{"$f":"'Franchise operations Pt2 & Pt3'!I6*124%","v":22341.25829178443},{"$f":"'Franchise operations Pt2 & Pt3'!J6*124%","v":27703.160281812692},{"$f":"'Franchise operations Pt2 & Pt3'!K6*124%","v":34351.918749447737},{"$f":"'Franchise operations Pt2 & Pt3'!L6*124%","v":42596.379249315192}]
["Extra donuts(over) ",{"$f":"4000-('Franchise operations Pt2 & Pt3'!B5*'Financial information '!D32)","v":3120},{"$f":"'Franchise operations Pt2 & Pt3'!B7*124%","v":3868.8},{"$f":"'Franchise operations Pt2 & Pt3'!C7*124%","v":4797.3119999999999},{"$f":"'Franchise operations Pt2 & Pt3'!D7*124%","v":5948.6668799999998},{"$f":"'Franchise operations Pt2 & Pt3'!E7*124%","v":7376.3469311999997},{"$f":"'Franchise operations Pt2 & Pt3'!F7*124%","v":9146.6701946880003},{"$f":"'Franchise operations Pt2 & Pt3'!G7*124%","v":11341.87104141312},{"$f":"'Franchise operations Pt2 & Pt3'!H7*124%","v":14063.920091352269},{"$f":"'Franchise operations Pt2 & Pt3'!I7*124%","v":17439.260913276812},{"$f":"'Franchise operations Pt2 & Pt3'!J7*124%","v":21624.683532463248},{"$f":"'Franchise operations Pt2 & Pt3'!K7*124%","v":26814.607580254429},{"$f":"'Franchise operations Pt2 & Pt3'!L7*124%","v":33250.113399515489}]
["Unsatisfied customers (short)",{"$f":"4000-('Financial information '!E32*B5)","v":2960},{"$f":"'Franchise operations Pt2 & Pt3'!B8*124%","v":3670.4},{"$f":"'Franchise operations Pt2 & Pt3'!C8*124%","v":4551.2960000000003},{"$f":"'Franchise operations Pt2 & Pt3'!D8*124%","v":5643.6070399999999},{"$f":"'Franchise operations Pt2 & Pt3'!E8*124%","v":6998.0727295999995},{"$f":"'Franchise operations Pt2 & Pt3'!F8*124%","v":8677.610184703999},{"$f":"'Franchise operations Pt2 & Pt3'!G8*124%","v":10760.236629032959},{"$f":"'Franchise operations Pt2 & Pt3'!H8*124%","v":13342.693420000869},{"$f":"'Franchise operations Pt2 & Pt3'!I8*124%","v":16544.939840801078},{"$f":"'Franchise operations Pt2 & Pt3'!J8*124%","v":20515.725402593336},{"$f":"'Franchise operations Pt2 & Pt3'!K8*124%","v":25439.499499215737},{"$f":"'Franchise operations Pt2 & Pt3'!L8*124%","v":31544.979379027514}]
["Revenue"]
["coffee ",{"$f":"4*B5","v":16000},{"$f":"4*C5","v":19840},24601.599999999999,30505.983999999997,37827.420159999994,46906.000998399992,58163.441238015992,72122.667135139825,89432.107247573382,110895.81298699099,137510.80810386883,170513.40204879735]
["donut",{"$f":"4*B6","v":15988},19825.12,24583.148799999999,30483.104511999998,37799.049594879994,46870.821497651195,58119.818657087482,72068.57513478848,89365.033167137721,110812.64112725077,137407.67499779095,170385.51699726077]
["Revenue from day old sales ",12480,15475.2,19189.248,23794.667519999999,29505.387724799999,36586.680778752001,45367.48416565248,56255.680365409076,69757.043653107248,86498.734129852994,107258.43032101772,133000.45359806195]
["Total Revenue",{"$f":"SUM(B10:B12)","v":44468},{"$f":"SUM(C10:C12)","v":55140.319999999992},68373.996799999994,84783.75603199999,105131.85747967998,130363.5032748032,161650.74406075594,200446.9226353374,248554.18406781834,308207.18824409472,382176.91342267755,473899.37264412001]
["Expenses"]
["Fixed Expenses",7050,{"$f":"B15+7000","v":14050},{"$f":"C15+7000","v":21050},{"$f":"D15+7000","v":28050},35050,42050,49050,56050,63050,70050,77050,84050]
["Total Fixed Expense",{"$f":"B15","v":7050},{"$f":"C15","v":14050},{"$f":"D15","v":21050},28050,35050,42050,49050,56050,63050,70050,77050,84050]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"0.35*B10","v":5600},{"$f":"0.35*C10","v":6944},{"$f":"0.35*D10","v":8610.56},10677.094399999998,13239.597055999997,16417.100349439996,20357.204433305596,25242.933497298938,31301.237536650682,38813.534545446841,48128.782836354083,59679.690717079066]
["Donut Variable expense",{"$f":"0.5*B11","v":7994},{"$f":"0.5*C11","v":9912.56},{"$f":"0.5*D11","v":12291.5744},15241.552255999999,18899.524797439997,23435.410748825598,29059.909328543741,36034.28756739424,44682.51658356886,55406.320563625384,68703.837498895475,85192.758498630385]
["Total Variable Expenses",{"$f":"B19+B20","v":13594},{"$f":"C19+C20","v":16856.559999999998},{"$f":"D19+D20","v":20902.134399999999},25918.646655999997,32139.121853439996,39852.51109826559,49417.113761849338,61277.221064693178,75983.754120219543,94219.855109072232,116832.62033524955,144872.44921570946]
["Expenses: due to lost sales",{"$f":"0.85*3","v":2.5499999999999998},{"$f":"0.85*3","v":2.5499999999999998},2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998]
["Total  Expenses",{"$f":"B21+B22+B16","v":20646.55},{"$f":"C21+C22+C16","v":30909.109999999997},41954.684399999998,53971.196656,67191.671853439999,81905.061098265593,98469.663761849341,117329.77106469318,139036.30412021955,164272.40510907222,193885.17033524957,228924.99921570945]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B13-B23","v":23821.45},{"$f":"C13-C23","v":24231.209999999995},26419.312399999995,30812.55937599999,37940.185626239982,48458.442176537603,63181.0802989066,83117.151570644215,109517.87994759879,143934.7831350225,188291.74308742798,244974.37342841056,{"$f":"SUM(B25:M25)","v":1024700.1710467883}]
[]
["Part 3"]
["HIGH DEMAND"]
["Month "]
["Demand",{"$f":"4000*124%","v":4960},{"$f":"B30*124%","v":6150.4},{"$f":"C30*124%","v":7626.4959999999992},9456.8550399999986,11726.500249599998,14540.860309503998,18030.666783784956,22358.026811893345,27723.953246747747,34377.702025967206,42628.350512199337,52859.154635127175]
["satisfied demand",{"$f":"4000*124%","v":4960},{"$f":"B31*124%","v":6150.4},{"$f":"C31*124%","v":7626.4959999999992},9456.8550399999986,11726.500249599998,14540.860309503998,18030.666783784956,22358.026811893345,27723.953246747747,34377.702025967206,42628.350512199337,52859.154635127175]
["Extra donuts(over) ",{"$f":"(B31*124%)-B31","v":1190.3999999999996},{"$f":"B32*124%","v":1476.0959999999995},{"$f":"C32*124%","v":1830.3590399999994},2269.6452095999994,2814.3600599039992,3489.8064742809588,4327.3600281083891,5365.926434854402,6653.7487792194588,8250.6484862321286,10230.804122927839,12686.19711243052]
["Unsatisfied customers (short)",{"$f":"3*132%","v":3.96},{"$f":"B33*124%","v":4.9104000000000001},{"$f":"C33*124%","v":6.0888960000000001},7.5502310399999999,9.3622864896000006,11.609235247104001,14.395451706408961,17.850360115947112,22.13444654377442,27.446713714280282,34.033925005707552,42.20206700707736]
["Revenue"]
["coffee ",{"$f":"4*B30","v":19840},{"$f":"4*C30","v":24601.599999999999},{"$f":"4*D30","v":30505.983999999997},37827.420159999994,46906.000998399992,58163.441238015992,72122.667135139825,89432.107247573382,110895.81298699099,137510.80810386883,170513.40204879735,211436.6185405087]
["donut",{"$f":"B30*3.5","v":17360},{"$f":"C30*3.5","v":21526.399999999998},{"$f":"D30*3.5","v":26692.735999999997},33098.992639999997,41042.750873599995,50893.011083263991,63107.333743247349,78253.093841626716,97033.836363617113,120321.95709088522,149199.22679269768,185007.04122294512]
["Revenue from day old sales ",{"$f":"B30*1.25","v":6200},{"$f":"C30*1.25","v":7688},9533.119999999999,11821.068799999997,14658.125311999996,18176.075386879998,22538.333479731195,27947.533514866682,34654.941558434686,42972.12753245901,53285.438140249171,66073.943293908975]
["Total Revenue",{"$f":"SUM(B35:B37)","v":43400},{"$f":"SUM(C35:C37)","v":53816},66731.839999999997,82747.481599999985,102606.87718399998,127232.52770815998,157768.33435811839,195632.73460406679,242584.5909090428,300804.8927272131,372998.0669817442,462517.60305736278]
["Expenses"]
["Fixed Expenses",7050,{"$f":"B40+7000","v":14050},{"$f":"C40+7000","v":21050},28050,35050,42050,49050,56050,63050,70050,77050,84050]
["Total Fixed Expense",{"$f":"B40","v":7050},{"$f":"C40","v":14050},21050,28050,35050,42050,49050,56050,63050,70050,77050,84050]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"0.35*B30","v":1736},{"$f":"0.35*C30","v":2152.64},{"$f":"0.35*D30","v":2669.2735999999995},3309.8992639999992,4104.2750873599989,5089.3011083263991,6310.7333743247345,7825.3093841626705,9703.3836363617102,12032.195709088521,14919.922679269766,18500.704122294512]
["Donut Variable expense",{"$f":"0.5*B30","v":2480},{"$f":"0.5*C30","v":3075.2},{"$f":"0.5*D30","v":3813.2479999999996},4728.4275199999993,5863.250124799999,7270.430154751999,9015.3333918924782,11179.013405946673,13861.976623373874,17188.851012983603,21314.175256099668,26429.577317563588]
["Total Variable Expenses",{"$f":"B44+B45","v":4216},{"$f":"C44+C45","v":5227.84},{"$f":"D44+D45","v":6482.5215999999991},8038.326783999999,9967.5252121599988,12359.731263078398,15326.066766217213,19004.322790109341,23565.360259735586,29221.046722072126,36234.097935369435,44930.281439858096]
["Expenses: due to lost sales",{"$f":"0.85*3","v":2.5499999999999998},{"$f":"0.85*3","v":2.5499999999999998},2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998]
["Total  Expenses",{"$f":"B46+B47+B41","v":11268.55},{"$f":"C46+C47+C41","v":19280.39},27535.071599999999,36090.876784,45020.075212159994,54412.281263078396,64378.616766217208,75056.872790109337,86617.910259735581,99273.596722072121,113286.64793536943,128982.8314398581]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B38-B48","v":32131.45},{"$f":"C38-C48","v":34535.61},39196.768400000001,46656.604815999985,57586.801971839988,72820.246445081575,93389.717591901179,120575.86181395745,155966.68064930721,201531.29600514099,259711.41904637477,333534.77161750465,{"$f":"SUM(B50:M50)","v":1447637.2283571078}]
[]
["Part 3"]
["LOW DEMAND"]
["Month "]
["Demand",{"$f":"('Franchise operations Pt2 & Pt3'!B5*25%)+B5","v":5000},{"$f":"('Franchise operations Pt2 & Pt3'!C5*25%)+C5","v":6200},{"$f":"('Franchise operations Pt2 & Pt3'!D5*25%)+D5","v":7688},{"$f":"('Franchise operations Pt2 & Pt3'!E5*25%)+E5","v":9533.119999999999},{"$f":"('Franchise operations Pt2 & Pt3'!F5*25%)+F5","v":11821.068799999997},{"$f":"('Franchise operations Pt2 & Pt3'!G5*25%)+G5","v":14658.125311999996},{"$f":"('Franchise operations Pt2 & Pt3'!H5*25%)+H5","v":18176.075386879998},{"$f":"('Franchise operations Pt2 & Pt3'!I5*25%)+I5","v":22538.333479731195},{"$f":"('Franchise operations Pt2 & Pt3'!J5*25%)+J5","v":27947.533514866682},{"$f":"('Franchise operations Pt2 & Pt3'!K5*25%)+K5","v":34654.941558434686},{"$f":"('Franchise operations Pt2 & Pt3'!L5*25%)+L5","v":42972.12753245901},{"$f":"('Franchise operations Pt2 & Pt3'!M5*25%)+M5","v":53285.438140249171}]
["satisfied demand",{"$f":"B55-3","v":4997},{"$f":"C55-3","v":6197},7685,9530.119999999999,11818.068799999997,14655.125311999996,18173.075386879998,22535.333479731195,27944.533514866682,34651.941558434686,42969.12753245901,53282.438140249171]
["Extra donuts(over) ",{"$f":"(B56*124%)-B56","v":1199.2799999999997},{"$f":"(C56*124%)-C56","v":1487.2799999999997},1844.3999999999996,2287.228799999999,2836.3365119999999,3517.2300748800008,4361.5380928511986,5408.4800351354861,6706.6880435680032,8316.4659740243223,10312.59060779016,12787.785153659803]
["Unsatisfied customers (short)",{"$f":"3*124%","v":3.7199999999999998},{"$f":"3*124%","v":3.7199999999999998},3.7199999999999998,3.7199999999999998,3.7199999999999998,3.7199999999999998,3.7199999999999998,3.7199999999999998,3.7199999999999998,3.7199999999999998,3.7199999999999998,3.7199999999999998]
["Revenue"]
["coffee ",{"$f":"4*B55","v":20000},{"$f":"4*C55","v":24800},30752,38132.479999999996,47284.275199999989,58632.501247999986,72704.301547519994,90153.333918924778,111790.13405946673,138619.76623373874,171888.51012983604,213141.75256099668]
["donut",{"$f":"B55*3.5","v":17500},{"$f":"C55*3.5","v":21700},26908,33365.919999999998,41373.740799999992,51303.438591999991,63616.263854079996,78884.167179059179,97816.367302033381,121292.2954545214,150402.44636360655,186499.0334908721]
["Revenue from day old sales ",{"$f":"B55*1.25","v":6250},{"$f":"C55*1.25","v":7750},9610,11916.399999999998,14776.335999999996,18322.656639999994,22720.094233599997,28172.916849663994,34934.416893583351,43318.676948043358,53715.159415573762,66606.797675311464]
["Total Revenue",{"$f":"SUM(B60:B62)","v":43750},{"$f":"SUM(C60:C62)","v":54250},67270,83414.799999999988,103434.35199999997,128258.59647999998,159040.65963519996,197210.41794764798,244540.91825508347,303230.73863630352,376006.11590901634,466247.58372718026]
["Expenses"]
["Fixed Expenses",7050,7051,7052,7053,7054,7055,7056,7057,7058,7059,7060,7061]
["Total Fixed Expense",{"$f":"B65","v":7050},{"$f":"C65","v":7051},7052,7053,7054,7055,7056,7057,7058,7059,7060,7061]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"0.35*B55","v":1750},{"$f":"0.35*C55","v":2170},2690.7999999999997,3336.5919999999996,4137.3740799999987,5130.3438591999984,6361.6263854079989,7888.4167179059177,9781.6367302033377,12129.229545452139,15040.244636360652,18649.90334908721]
["Donut Variable expense",{"$f":"0.5*B55","v":2500},{"$f":"0.5*C55","v":3100},3844,4766.5599999999995,5910.5343999999986,7329.0626559999982,9088.0376934399992,11269.166739865597,13973.766757433341,17327.470779217343,21486.063766229505,26642.719070124585]
["Total Variable Expenses",{"$f":"B69+B70","v":4250},{"$f":"C69+C70","v":5270},6534.7999999999993,8103.1519999999991,10047.908479999998,12459.406515199997,15449.664078847998,19157.583457771514,23755.403487636679,29456.70032466948,36526.308402590155,45292.622419211795]
["Expenses: due to lost sales",{"$f":"0.85*3","v":2.5499999999999998},{"$f":"0.85*3","v":2.5499999999999998},2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998,2.5499999999999998]
["Total  Expenses",{"$f":"B71+B72+B66","v":11302.55},{"$f":"C71+C72+C66","v":12323.55},13589.349999999999,15158.701999999999,17104.458479999998,19516.956515199996,22508.214078847996,26217.133457771513,30815.953487636678,36518.250324669483,43588.858402590158,52356.172419211798]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Total "]
["Profit Donuts and Coffee",{"$f":"B63-B73","v":32447.45},{"$f":"C63-C73","v":41926.449999999997},53680.65,68256.097999999984,86329.893519999969,108741.63996479998,136532.44555635197,170993.28448987647,213724.9647674468,266712.48831163405,332417.25750642619,413891.41130796843,{"$f":"SUM(B75:M75)","v":1925654.0334245041}]

{"sheet":"Expected Values Pt3","index":6,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[46,2,46,4],[54,2,54,4],[2,2,2,4],[10,2,10,4],[17,2,17,4],[24,2,24,4],[31,2,31,4],[38,2,38,4]]}
[null,"PAYOFF TABLE"]
[]
[null,null,"State of Nature",null,null,null,null,"Summary of Results ","Methods "]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,{"$f":"B4","v":"Decision Alternatives"},"Maximin","MaxiMax","Laplace ","MinMax regret","EVUII","EOL"]
[null,"current operation",3000,4000,4800]
[null,"Franchise",5000,4000,4960]
[null,null,null,null,null,0.2,null,"Decision Alternatives"]
[null,"DM UNDER IGNORANCE",null,null,null,0.55000000000000004]
[null,null,null,null,null,0.25,null,"Kiana should choose to:"]
[null,"Maximin"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High ",null,null,"Because:"]
[]
[null,null,"Nil","Nil","Nil"]
[]
[]
[null,"Maximax"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[null,null,"Nil","Nil","Nil"]
[]
[]
[null,"Laplace"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[null,null,"Nil","Nil","Nil"]
[]
[]
[null,"Minimax Regret"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[]
[null,null,"Nil","Nil","Nil"]
[]
[null,"DM UNDER RISK"]
[null,"EVUII"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[null,null,"Nil","Nil","Nil"]
[]
[]
[null,"EVUPI"]
[null,null,"State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[null,null,"Nil","Nil","Nil"]
[]
[null,"EVPI"]
[]
[null,"EOL"]
[null,"Regret table","State of Nature"]
[null,"Decision Alternatives","Low ","Average ","High "]
[null,"Probability"]
[]
[null,null,"Nil","Nil","Nil"]

{"sheet":"Sheet9","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}